package com.erp.hibernate.dao;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.erp.hibernate.beans.Storage;

/**
 * A data access object (DAO) providing persistence and search support for
 * Storage entities. Transaction control of the save(), update() and delete()
 * operations can directly support Spring container-managed transactions or they
 * can be augmented to handle user-managed Spring transactions. Each of these
 * methods provides additional information for how to configure it for the
 * desired type of transaction control.
 * 
 * @see com.erp.hibernate.dao.Storage
 * @author MyEclipse Persistence Tools
 */

public class StorageDAO extends HibernateDaoSupport {
	private static final Log log = LogFactory.getLog(StorageDAO.class);
	// property constants
	public static final String GOODSID = "goodsid";
	public static final String GOODSNAME = "goodsname";
	public static final String TRADEMARK = "trademark";
	public static final String SPEC = "spec";
	public static final String QUANLITY = "quanlity";
	public static final String DEPOTTYPE = "depottype";
	public static final String REMARK = "remark";

	protected void initDao() {
		// do nothing
	}

	public void save(Storage transientInstance) {
		log.debug("saving Storage instance");
		try {
			getHibernateTemplate().save(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

	public void delete(Storage persistentInstance) {
		log.debug("deleting Storage instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	public Storage findById(java.lang.Integer id) {
		log.debug("getting Storage instance with id: " + id);
		try {
			Storage instance = (Storage) getHibernateTemplate().get(
					"com.erp.hibernate.dao.Storage", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(Storage instance) {
		log.debug("finding Storage instance by example");
		try {
			List results = getHibernateTemplate().findByExample(instance);
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding Storage instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from Storage as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	public List findByGoodsid(Object goodsid) {
		return findByProperty(GOODSID, goodsid);
	}

	public List findByGoodsname(Object goodsname) {
		return findByProperty(GOODSNAME, goodsname);
	}

	public List findByTrademark(Object trademark) {
		return findByProperty(TRADEMARK, trademark);
	}

	public List findBySpec(Object spec) {
		return findByProperty(SPEC, spec);
	}

	public List findByQuanlity(Object quanlity) {
		return findByProperty(QUANLITY, quanlity);
	}

	public List findByDepottype(Object depottype) {
		return findByProperty(DEPOTTYPE, depottype);
	}

	public List findByRemark(Object remark) {
		return findByProperty(REMARK, remark);
	}

	public List findAll() {
		log.debug("finding all Storage instances");
		try {
			String queryString = "from Storage";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public Storage merge(Storage detachedInstance) {
		log.debug("merging Storage instance");
		try {
			Storage result = (Storage) getHibernateTemplate().merge(
					detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	public void attachDirty(Storage instance) {
		log.debug("attaching dirty Storage instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public void attachClean(Storage instance) {
		log.debug("attaching clean Storage instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public static StorageDAO getFromApplicationContext(ApplicationContext ctx) {
		return (StorageDAO) ctx.getBean("StorageDAO");
	}
}